package com.lfxfs.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * TODO 该mapper所有方法存在sql注入风险，请不要对外暴露
 */
@Mapper
public interface SchemasMapper {
    //根据表名查表信息Mysql
    Map<String,String> showTableComment(@Param("tableName") String tableName);
    //根据表名查字段信息Mysql
    List<Map<String,String>> showFullColumns(@Param("tableName")String tableName);
    //根据参数动态查询结果
    List<Map<String,Object>> select(@Param("table") String table,@Param("fields")String fields,@Param("sqlwhere")String sqlwhere,@Param("orderby")String orderby);

}
